Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$BACKUP_PIECE

`V$BACKUP_PIECE` displays information about backup pieces from the control file. Each backup set consists of one or more backup pieces.

Column | Datatype | Description
--- | --- | ---
`RECID` | `NUMBER` | Backup piece record ID
`STAMP` | `NUMBER` | Backup piece record stamp
`SET_STAMP` | `NUMBER` | Backup set stamp
`SET_COUNT` | `NUMBER` | Backup set count
`PIECE#` | `NUMBER` | Backup piece number (1-N)
`COPY#` | `NUMBER` | Indicates the copy number for backup pieces created with duplex enabled. 1 if the backup piece is not duplexed.
`DEVICE_TYPE` | `VARCHAR2(17)` | Type of the device on which the backup piece resides. Set to DISK for backup sets on disk. See Also: V$BACKUP_DEVICE
`HANDLE` | `VARCHAR2(513)` | Backup piece handle identifies the backup piece on restore
`COMMENTS` | `VARCHAR2(64)` | Comment returned by the operating system or storage subsystem. Set to NULL for backup pieces on disk. This value is informational only; not needed for restore.
`MEDIA` | `VARCHAR2(65)` | Name of the media on which the backup piece resides. This value is informational only; not needed for restore.
`MEDIA_POOL` | `NUMBER` | The media pool in which the copy resides. This is the same value that was entered in the `POOL` operand of the Recovery Manager backup command.
`CONCUR` | `VARCHAR2(3)` | (`YES` | `NO`) Indicates whether the piece on a media that can be accessed concurrently
`TAG` | `VARCHAR2(32)` | Backup piece tag. The tag is specified at backup set level, but stored at piece level.
`STATUS` | `VARCHAR2(1)` | Indicates the status of the piece: `A` (available), `D` (deleted), or `X` (expired)
`START_TIME` | `DATE` | Starting time
`COMPLETION_TIME` | `DATE` | Completion time
`ELAPSED_SECONDS` | `NUMBER` | Number of elapsed seconds
`DELETED` | `VARCHAR2(3)` | (`YES`/`NO`) `NO` indicates that the file still exists. `YES` indicates the file no longer exists because it has been deleted.
`BYTES` | `NUMBER` | Size of the backup piece (in bytes)
`IS_RECOVERY_DEST_FILE` | `VARCHAR2(3)` | Indicates whether the file was created in the flash recovery area (`YES`) or not (`NO`)
`RMAN_STATUS_RECID` | `NUMBER` | Owning `V$RMAN_STATUS` record ID
`RMAN_STATUS_STAMP` | `NUMBER` | Owning `V$RMAN_STATUS` record stamp
`COMPRESSED` | `VARCHAR2(3)` | Indicates whether the backup piece is compressed (`YES`) or not (`NO`)